package com.dmgis.hndz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dmgis.hndz.pojo.Ybba01b;
import com.dmgis.hndz.pojo.Ybba01c;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author PC
* @description 针对表【ybba01c(市级预警产品表)】的数据库操作Mapper
* @createDate 2024-01-30 23:28:00
* @Entity com.dmgis.hndz.pojo.Ybba01c
*/
@Mapper
public interface Ybba01cMapper extends BaseMapper<Ybba01c> {
    @Select("select max(YBBA01C140) from YBBA01C where YBBA01C020='${number}' and ybba01c160 = '${userName}'")
    String selectMaxDocByType(@Param("number") String number, @Param("userName") String userName);


    List<Ybba01c> getYj(@Param("startTime") String startTime,
                        @Param("endTime") String endTime,
                        @Param("yjLevel") Integer yjLevel,
                        @Param("advcode") String advcode);

    /**
     * 查询县级预警
     *
     * @param dateType 1：本年，2：本月，3：本日
     * @return
     */
    List<Ybba01c> getYbba01cList(Integer dateType);

}




